object frlRelNFOperacoes: TfrlRelNFOperacoes
  Left = 344
  Top = 183
  Caption = 'frlRelNFOperacoes'
  ClientHeight = 613
  ClientWidth = 862
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  Scaled = False
  PixelsPerInch = 96
  TextHeight = 13
  object QuickRep1: TQuickRep
    Left = 0
    Top = -8
    Width = 794
    Height = 1123
    Frame.Color = clBlack
    Frame.DrawTop = False
    Frame.DrawBottom = False
    Frame.DrawLeft = False
    Frame.DrawRight = False
    DataSet = CDSNFOPERACOES
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -13
    Font.Name = 'Arial'
    Font.Style = []
    Functions.Strings = (
      'PAGENUMBER'
      'COLUMNNUMBER'
      'REPORTTITLE')
    Functions.DATA = (
      '0'
      '0'
      #39#39)
    Options = [FirstPageHeader, LastPageFooter]
    Page.Columns = 1
    Page.Orientation = poPortrait
    Page.PaperSize = A4
    Page.Values = (
      100.000000000000000000
      2970.000000000000000000
      100.000000000000000000
      2100.000000000000000000
      100.000000000000000000
      100.000000000000000000
      0.000000000000000000)
    PrinterSettings.Copies = 1
    PrinterSettings.OutputBin = Auto
    PrinterSettings.Duplex = False
    PrinterSettings.FirstPage = 0
    PrinterSettings.LastPage = 0
    PrinterSettings.UseStandardprinter = False
    PrinterSettings.UseCustomBinCode = False
    PrinterSettings.CustomBinCode = 0
    PrinterSettings.ExtendedDuplex = 0
    PrinterSettings.UseCustomPaperCode = False
    PrinterSettings.CustomPaperCode = 0
    PrinterSettings.PrintMetaFile = False
    PrinterSettings.PrintQuality = 0
    PrinterSettings.Collate = 0
    PrinterSettings.ColorOption = 0
    PrintIfEmpty = True
    SnapToGrid = True
    Units = MM
    Zoom = 100
    PrevFormStyle = fsNormal
    PreviewInitialState = wsNormal
    PrevInitialZoom = qrZoomToFit
    PreviewDefaultSaveType = stQRP
    object grImpostoFixo: TQRGroup
      Left = 38
      Top = 38
      Width = 718
      Height = 107
      Frame.Color = clBlack
      Frame.DrawTop = False
      Frame.DrawBottom = True
      Frame.DrawLeft = False
      Frame.DrawRight = False
      AlignToBottom = False
      Color = clWhite
      TransparentBand = False
      ForceNewColumn = False
      ForceNewPage = True
      Size.Values = (
        283.104166666666700000
        1899.708333333333000000)
      PreCaluculateBandHeight = False
      KeepOnOnePage = False
      Expression = 'CDS.CFOP'
      Master = QuickRep1
      ReprintOnNewPage = False
      object QRLabel3: TQRLabel
        Left = 216
        Top = 4
        Width = 334
        Height = 33
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          87.312500000000000000
          571.500000000000000000
          10.583333333333330000
          883.708333333333300000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'Relat'#243'rio de NF-Opera'#231#245'es'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -27
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 20
      end
      object lbImpostoFixo: TQRLabel
        Left = 58
        Top = 121
        Width = 84
        Height = 17
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          44.979166666666670000
          153.458333333333300000
          320.145833333333300000
          222.250000000000000000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'Imposto (Fixo)'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -13
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 10
      end
      object QRDBText2: TQRDBText
        Left = 92
        Top = 89
        Width = 421
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          243.416666666666700000
          235.479166666666700000
          1113.895833333333000000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Color = clWhite
        DataSet = CDSNFOPERACOES
        DataField = 'DESCRICAO'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRDBText3: TQRDBText
        Left = 520
        Top = 89
        Width = 50
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          1375.833333333333000000
          235.479166666666700000
          132.291666666666700000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Color = clWhite
        DataSet = CDSNFOPERACOES
        DataField = 'CFOP'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRDBText4: TQRDBText
        Left = 1
        Top = 89
        Width = 66
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          2.645833333333333000
          235.479166666666700000
          174.625000000000000000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Color = clWhite
        DataSet = CDSNFOPERACOES
        DataField = 'ID_OPERACAO'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRDBText5: TQRDBText
        Left = 592
        Top = 89
        Width = 49
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          1566.333333333333000000
          235.479166666666700000
          129.645833333333300000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = False
        AutoStretch = False
        Color = clWhite
        DataSet = CDSNFOPERACOES
        DataField = 'TIPONF'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRShape1: TQRShape
        Left = 0
        Top = 85
        Width = 717
        Height = 1
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          2.645833333333333000
          0.000000000000000000
          224.895833333333300000
          1897.062500000000000000)
        Shape = qrsRectangle
        VertAdjust = 0
      end
      object QRLabel1: TQRLabel
        Left = 1
        Top = 68
        Width = 85
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          2.645833333333333000
          179.916666666666700000
          224.895833333333300000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'C'#243'digo Opera'#231#227'o'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRLabel2: TQRLabel
        Left = 94
        Top = 68
        Width = 116
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          248.708333333333300000
          179.916666666666700000
          306.916666666666700000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'Descri'#231#227'o da Opera'#231#227'o'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRLabel4: TQRLabel
        Left = 522
        Top = 68
        Width = 28
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          1381.125000000000000000
          179.916666666666700000
          74.083333333333330000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'CFOP'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRLabel5: TQRLabel
        Left = 593
        Top = 68
        Width = 37
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          1568.979166666667000000
          179.916666666666700000
          97.895833333333330000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'Tipo NF'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
    end
    object QRBand1: TQRBand
      Left = 38
      Top = 145
      Width = 718
      Height = 43
      Frame.Color = clBlack
      Frame.DrawTop = False
      Frame.DrawBottom = False
      Frame.DrawLeft = False
      Frame.DrawRight = False
      AlignToBottom = False
      Color = clWhite
      TransparentBand = False
      ForceNewColumn = False
      ForceNewPage = False
      Size.Values = (
        113.770833333333300000
        1899.708333333333000000)
      PreCaluculateBandHeight = False
      KeepOnOnePage = False
      BandType = rbDetail
      object QRDBText1: TQRDBText
        Left = 68
        Top = 1
        Width = 68
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          179.916666666666700000
          2.645833333333333000
          179.916666666666700000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Color = clWhite
        DataSet = CDSNFOPERACOES
        DataField = 'TIPOIMPOSTO'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRLabel6: TQRLabel
        Left = 1
        Top = 1
        Width = 64
        Height = 15
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          39.687500000000000000
          2.645833333333333000
          2.645833333333333000
          169.333333333333300000)
        Alignment = taLeftJustify
        AlignToBand = False
        AutoSize = True
        AutoStretch = False
        Caption = 'Tipo Imposto:'
        Color = clWhite
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Transparent = False
        WordWrap = True
        ExportAs = exptText
        WrapStyle = BreakOnSpaces
        FontSize = 8
      end
      object QRShape2: TQRShape
        Left = 0
        Top = 17
        Width = 717
        Height = 1
        Frame.Color = clBlack
        Frame.DrawTop = False
        Frame.DrawBottom = False
        Frame.DrawLeft = False
        Frame.DrawRight = False
        Size.Values = (
          2.645833333333333000
          0.000000000000000000
          44.979166666666670000
          1897.062500000000000000)
        Shape = qrsRectangle
        VertAdjust = 0
      end
    end
  end
  object RelNFOperacoes: TQuery
    DatabaseName = 'industrial'
    SQL.Strings = (
      'SELECT DISTINCT N.ID_OPERACAO, N.CFOP, N.DESCRICAO, N.TIPONF,'
      '(CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      ' END) TIPOTRIBUTACAO, '
      ' (CASE WHEN INC.MODBC = 0 THEN '
      '    '#39'0 - Margem Valor Agregado (%)'#39
      '  ELSE'
      '    CASE WHEN INC.MODBC = 1 THEN '
      '      '#39'1 - Pauta (valor)'#39
      '    ELSE'
      '      CASE WHEN INC.MODBC = 2 THEN '
      '    '#39'2 - Pre'#231'o Tabelado Max. (valor)'#39
      '   ELSE'
      '     CASE WHEN INC.MODBC = 3 THEN '
      '       '#39'3 - Valor Opera'#231#227'o'#39
      '     END'
      '    END'
      '  END'
      ' END) MODBCNCM, '
      ' (CASE WHEN I.MODBC = 0 THEN '
      '    '#39'0 - Margem Valor Agregado (%)'#39
      '  ELSE'
      '    CASE WHEN I.MODBC = 1 THEN '
      '      '#39'1 - Pauta (valor)'#39
      '    ELSE'
      '      CASE WHEN I.MODBC = 2 THEN '
      '    '#39'2 - Pre'#231'o Tabelado Max. (valor)'#39
      '   ELSE'
      '     CASE WHEN I.MODBC = 3 THEN '
      '       '#39'3 - Valor Opera'#231#227'o'#39
      '     END'
      '    END'
      '  END'
      ' END) MODBCFIXO,'
      ' (CASE WHEN NC.MODBC = 0 THEN '
      '    '#39'0 - Margem Valor Agregado (%)'#39
      '  ELSE'
      '    CASE WHEN NC.MODBC = 1 THEN '
      '      '#39'1 - Pauta (valor)'#39
      '    ELSE'
      '      CASE WHEN NC.MODBC = 2 THEN '
      '    '#39'2 - Pre'#231'o Tabelado Max. (valor)'#39
      '   ELSE'
      '     CASE WHEN NC.MODBC = 3 THEN '
      '       '#39'3 - Valor Opera'#231#227'o'#39
      '     END'
      '    END'
      '  END'
      ' END) MODBCUF, '
      ' (CASE WHEN VNC.NFNCM_TIPO_IMPOSTO IS NOT NULL THEN '
      '    VNC.NFNCM_TIPO_IMPOSTO'
      '  ELSE'
      '    CASE WHEN NC.TIPOIMPOSTO IS NOT NULL THEN '
      '      NC.TIPOIMPOSTO'
      '    ELSE'
      '      CASE WHEN I.TIPOIMPOSTO IS NOT NULL THEN '
      '        I.TIPOIMPOSTO'
      '      END'
      '    END'
      '   END) TIPOINPOSTO,'
      
        '        I.DESCRICAO AS DESCRICAO_FIXO_ICMS, N.NFOPER_LIVRE_ESTOQ' +
        'UE, N.NFOPER_LIVRE_PEDIDO,'
      
        '        VNC.NFNCM_TIPO_IMPOSTO AS TIPOIMPOSTOVARIAVELNCM, INC.DE' +
        'SCRICAO AS DESCRICAONCM,'
      
        '        INC.BASEDECALCULO AS BCNCM, INC.SOMA_VLRDESCONTO, INC.SO' +
        'MA_VLRFRETE, INC.SOMA_VLRIMPORTACAO, '
      
        '        INC.SOMA_VLRIPI, INC.SOMA_VLRMERCADORIA, INC.SOMA_VLROUT' +
        'RAS,'
      
        '        INC.SOMA_VLRSEGURO, NC.SOMA_VLRDESCONTO AS SOMA_VLRDESCO' +
        'NTOUF, NC.SOMA_VLRFRETE AS SOMA_VLRFRETEUF, NC.SOMA_VLRIMPORTACA' +
        'O AS SOMA_VLRIMPORTACAOUF, '
      
        '        NC.SOMA_VLRIPI AS SOMA_VLRIPIUF, NC.SOMA_VLRMERCADORIA A' +
        'S SOMA_VLRMERCADORIAUF, NC.SOMA_VLROUTRAS AS SOMA_VLROUTRASUF,'
      
        '        NC.SOMA_VLRSEGURO AS SOMA_VLRSEGUROUF, I.SOMA_VLRDESCONT' +
        'O AS SOMA_VLRDESCONTOFIXO, I.SOMA_VLRFRETE AS SOMA_VLRFRETEFIXO,' +
        ' '
      '        I.SOMA_VLRIMPORTACAO AS SOMA_VLRIMPORTACAOFIXO, '
      
        '        I.SOMA_VLRIPI AS SOMA_VLRIPIFIXO, I.SOMA_VLRMERCADORIA A' +
        'S SOMA_VLRMERCADORIAFIXO, I.SOMA_VLROUTRAS AS SOMA_VLROUTRASFIXO' +
        ','
      
        '        I.SOMA_VLRSEGURO AS SOMA_VLRSEGUROFIXO, INC.ALIQUOTA AS ' +
        'ALIQUOTANCM, M.MNCM_CODIGO AS ID_NCM, VNC.NFNCM_CFOP AS CFOPNCM,' +
        '  VNC.NFNCM_TIPO_IMPOSTO AS TIPO_IMPOSTO,'
      
        '        M.DESCRICAO AS ClasfiscalNCM,I.DESCRICAO AS DescricaoImp' +
        'ostoFIXO, I.ALIQUOTA AS ALIQUOTAFIXO, VN.NFNCMEST_SIGLA_ESTADO A' +
        'S SIGLA_ESTADO, '
      
        '        VN.NFNCMEST_TIPO_IMPOSTO AS TIPO_IMPOSTOUF, I.PCREDICMS ' +
        'AS PCREDFIXO, I.PDIF AS PDIFFIXO, MN.MNCM_CODIGO AS ID_NCMUF,'
      
        '        MN.DESCRICAO AS ClasfiscalNCMUF, VN.NFNCMEST_CFOP AS CFO' +
        'PUF, INC.DESCRICAO AS DescricaoImpostoNCM, '
      
        '        NC.DESCRICAO AS DescricaoImpostoNCMUF, NC.ALIQUOTA AS AL' +
        'IQUOTAUF, INC.PCREDICMS AS PCREDNCM, INC.PDIF AS PDIFNCM,'
      
        '        NC.PCREDICMS AS PCREDUF, NC.PDIF AS PDIFUF, I.TIPOIMPOST' +
        'O, VNC.NFNCM_TIPO_IMPOSTO,NC.TIPOIMPOSTO'
      
        'FROM NF_OPERACOES N LEFT OUTER JOIN IMPOSTOS I ON (N.NFOPER_ICMS' +
        '_FIXO_ID = I.ID_CODIGO)'
      
        '                    LEFT OUTER JOIN NF_OPERACOES_PORNCM VNC ON (' +
        'VNC.NFNCM_ID_OPERACAO = N.ID_OPERACAO AND N.NFOPER_ICMS_TIPOTRIB' +
        ' = 1)'
      
        '                    LEFT OUTER JOIN IMPOSTOS INC ON (INC.ID_CODI' +
        'GO = VNC.NFNCM_ID_TRIBUTACAO)'
      
        '                    LEFT OUTER JOIN MERCADORIA_NCM M ON (VNC.NFN' +
        'CM_ID_NCM = M.MNCM_ID_NCM)'
      
        '                    LEFT OUTER JOIN NF_OPERACOES_NCMPORESTADO VN' +
        ' ON (VN.NFNCMEST_ID_OPERACAO = N.ID_OPERACAO AND N.NFOPER_ICMS_T' +
        'IPOTRIB = 2)'
      
        '                    LEFT OUTER JOIN MERCADORIA_NCM MN ON (VN.NFN' +
        'CMEST_ID_NCM = MN.MNCM_ID_NCM)'
      
        '                    LEFT OUTER JOIN IMPOSTOS NC ON (NC.ID_CODIGO' +
        ' = VN.NFNCMEST_ID_IMPOSTO)'
      ''
      
        'GROUP BY N.CFOP, I.TIPOIMPOSTO, VNC.NFNCM_TIPO_IMPOSTO,NC.TIPOIM' +
        'POSTO, VN.NFNCMEST_SIGLA_ESTADO, N.ID_OPERACAO, N.DESCRICAO, N.T' +
        'IPONF,'
      
        '         N.NFOPER_ICMS_TIPOTRIB, INC.MODBC, I.MODBC, NC.MODBC, I' +
        '.DESCRICAO, N.NFOPER_LIVRE_ESTOQUE, N.NFOPER_LIVRE_PEDIDO,'
      
        '         INC.DESCRICAO, INC.ALIQUOTA, INC.BASEDECALCULO, INC.PDI' +
        'F, INC.PCREDICMS,'
      
        '         INC.SOMA_VLRDESCONTO, INC.SOMA_VLRFRETE, INC.SOMA_VLRIM' +
        'PORTACAO, INC.SOMA_VLRIPI, INC.SOMA_VLRMERCADORIA, INC.SOMA_VLRO' +
        'UTRAS,'
      
        '         INC.SOMA_VLRSEGURO, INC.ALIQUOTA_INTERNA, M.MNCM_CODIGO' +
        ', VNC.NFNCM_CFOP,'
      
        '         M.DESCRICAO, I.DESCRICAO, I.ALIQUOTA, VN.NFNCMEST_TIPO_' +
        'IMPOSTO, '
      
        '         I.PCREDICMS, I.PDIF, MN.MNCM_CODIGO, MN.DESCRICAO, VN.N' +
        'FNCMEST_CFOP,INC.DESCRICAO,'
      '        NC.DESCRICAO, NC.ALIQUOTA,INC.PCREDICMS, INC.PDIF,'
      
        '        NC.PCREDICMS, NC.PDIF, NC.SOMA_VLRDESCONTO, NC.SOMA_VLRF' +
        'RETE, NC.SOMA_VLRIMPORTACAO, '
      
        '        NC.SOMA_VLRIPI, NC.SOMA_VLRMERCADORIA, NC.SOMA_VLROUTRAS' +
        ','
      
        '        NC.SOMA_VLRSEGURO, I.SOMA_VLRDESCONTO, I.SOMA_VLRFRETE, ' +
        'I.SOMA_VLRIMPORTACAO, '
      '        I.SOMA_VLRIPI, I.SOMA_VLRMERCADORIA, I.SOMA_VLROUTRAS,'
      '        I.SOMA_VLRSEGURO'
      
        'ORDER BY N.CFOP, I.TIPOIMPOSTO, VNC.NFNCM_TIPO_IMPOSTO,NC.TIPOIM' +
        'POSTO, VN.NFNCMEST_SIGLA_ESTADO')
    Left = 805
    Top = 145
    object RelNFOperacoesID_OPERACAO: TFloatField
      FieldName = 'ID_OPERACAO'
    end
    object RelNFOperacoesCFOP: TStringField
      FieldName = 'CFOP'
      Size = 5
    end
    object RelNFOperacoesDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 100
    end
    object RelNFOperacoesTIPONF: TStringField
      FieldName = 'TIPONF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesTIPOTRIBUTACAO: TStringField
      FieldName = 'TIPOTRIBUTACAO'
      Size = 72
    end
    object RelNFOperacoesDESCRICAO_FIXO_ICMS: TStringField
      FieldName = 'DESCRICAO_FIXO_ICMS'
      Size = 50
    end
    object RelNFOperacoesNFOPER_LIVRE_ESTOQUE: TStringField
      FieldName = 'NFOPER_LIVRE_ESTOQUE'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesNFOPER_LIVRE_PEDIDO: TStringField
      FieldName = 'NFOPER_LIVRE_PEDIDO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesTIPOIMPOSTOVARIAVELNCM: TStringField
      FieldName = 'TIPOIMPOSTOVARIAVELNCM'
      Size = 10
    end
    object RelNFOperacoesDESCRICAONCM: TStringField
      FieldName = 'DESCRICAONCM'
      Size = 50
    end
    object RelNFOperacoesBCNCM: TFloatField
      FieldName = 'BCNCM'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesALIQUOTANCM: TFloatField
      FieldName = 'ALIQUOTANCM'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesID_NCM: TStringField
      FieldName = 'ID_NCM'
      Size = 15
    end
    object RelNFOperacoesCFOPNCM: TStringField
      FieldName = 'CFOPNCM'
      Size = 5
    end
    object RelNFOperacoesTIPO_IMPOSTO: TStringField
      FieldName = 'TIPO_IMPOSTO'
      Size = 10
    end
    object RelNFOperacoesCLASFISCALNCM: TStringField
      FieldName = 'CLASFISCALNCM'
      Size = 50
    end
    object RelNFOperacoesDESCRICAOIMPOSTOFIXO: TStringField
      FieldName = 'DESCRICAOIMPOSTOFIXO'
      Size = 50
    end
    object RelNFOperacoesALIQUOTAFIXO: TFloatField
      FieldName = 'ALIQUOTAFIXO'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesSIGLA_ESTADO: TStringField
      FieldName = 'SIGLA_ESTADO'
      Size = 2
    end
    object RelNFOperacoesTIPO_IMPOSTOUF: TStringField
      FieldName = 'TIPO_IMPOSTOUF'
      Size = 10
    end
    object RelNFOperacoesPCREDFIXO: TFloatField
      FieldName = 'PCREDFIXO'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesPDIFFIXO: TFloatField
      FieldName = 'PDIFFIXO'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesID_NCMUF: TStringField
      FieldName = 'ID_NCMUF'
      Size = 15
    end
    object RelNFOperacoesCLASFISCALNCMUF: TStringField
      FieldName = 'CLASFISCALNCMUF'
      Size = 50
    end
    object RelNFOperacoesCFOPUF: TStringField
      FieldName = 'CFOPUF'
      Size = 5
    end
    object RelNFOperacoesDESCRICAOIMPOSTONCM: TStringField
      FieldName = 'DESCRICAOIMPOSTONCM'
      Size = 50
    end
    object RelNFOperacoesDESCRICAOIMPOSTONCMUF: TStringField
      FieldName = 'DESCRICAOIMPOSTONCMUF'
      Size = 50
    end
    object RelNFOperacoesALIQUOTAUF: TFloatField
      FieldName = 'ALIQUOTAUF'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesPCREDNCM: TFloatField
      FieldName = 'PCREDNCM'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesPDIFNCM: TFloatField
      FieldName = 'PDIFNCM'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesPCREDUF: TFloatField
      FieldName = 'PCREDUF'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesPDIFUF: TFloatField
      FieldName = 'PDIFUF'
      DisplayFormat = '#,##0.00'
    end
    object RelNFOperacoesTIPOINPOSTO: TStringField
      FieldName = 'TIPOINPOSTO'
      Size = 10
    end
    object RelNFOperacoesMODBCNCM: TStringField
      FieldName = 'MODBCNCM'
      Size = 31
    end
    object RelNFOperacoesMODBCFIXO: TStringField
      FieldName = 'MODBCFIXO'
      Size = 31
    end
    object RelNFOperacoesMODBCUF: TStringField
      FieldName = 'MODBCUF'
      Size = 31
    end
    object RelNFOperacoesSOMA_VLRDESCONTO: TStringField
      FieldName = 'SOMA_VLRDESCONTO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRFRETE: TStringField
      FieldName = 'SOMA_VLRFRETE'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIMPORTACAO: TStringField
      FieldName = 'SOMA_VLRIMPORTACAO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIPI: TStringField
      FieldName = 'SOMA_VLRIPI'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRMERCADORIA: TStringField
      FieldName = 'SOMA_VLRMERCADORIA'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLROUTRAS: TStringField
      FieldName = 'SOMA_VLROUTRAS'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRSEGURO: TStringField
      FieldName = 'SOMA_VLRSEGURO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRDESCONTOUF: TStringField
      FieldName = 'SOMA_VLRDESCONTOUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRFRETEUF: TStringField
      FieldName = 'SOMA_VLRFRETEUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIMPORTACAOUF: TStringField
      FieldName = 'SOMA_VLRIMPORTACAOUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIPIUF: TStringField
      FieldName = 'SOMA_VLRIPIUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRMERCADORIAUF: TStringField
      FieldName = 'SOMA_VLRMERCADORIAUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLROUTRASUF: TStringField
      FieldName = 'SOMA_VLROUTRASUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRSEGUROUF: TStringField
      FieldName = 'SOMA_VLRSEGUROUF'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRDESCONTOFIXO: TStringField
      FieldName = 'SOMA_VLRDESCONTOFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRFRETEFIXO: TStringField
      FieldName = 'SOMA_VLRFRETEFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIMPORTACAOFIXO: TStringField
      FieldName = 'SOMA_VLRIMPORTACAOFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRIPIFIXO: TStringField
      FieldName = 'SOMA_VLRIPIFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRMERCADORIAFIXO: TStringField
      FieldName = 'SOMA_VLRMERCADORIAFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLROUTRASFIXO: TStringField
      FieldName = 'SOMA_VLROUTRASFIXO'
      FixedChar = True
      Size = 1
    end
    object RelNFOperacoesSOMA_VLRSEGUROFIXO: TStringField
      FieldName = 'SOMA_VLRSEGUROFIXO'
      FixedChar = True
      Size = 1
    end
  end
  object RelDsNFOperacoes: TDataSource
    DataSet = CDS
    Left = 808
    Top = 193
  end
  object QRTextFilter1: TQRTextFilter
    TextEncoding = DefaultEncoding
    Left = 816
    Top = 264
  end
  object QRCSVFilter1: TQRCSVFilter
    Separator = ','
    TextEncoding = DefaultEncoding
    Left = 816
    Top = 312
  end
  object QRPDFFilter1: TQRPDFFilter
    CompressionOn = False
    TextEncoding = ASCIIEncoding
    Left = 819
    Top = 368
  end
  object QRXMLSFilter1: TQRXMLSFilter
    TextEncoding = DefaultEncoding
    Left = 819
    Top = 416
  end
  object QRHTMLFilter1: TQRHTMLFilter
    MultiPage = False
    PageLinks = False
    FinalPage = 0
    FirstLastLinks = False
    Concat = False
    ConcatCount = 1
    LinkFontSize = 12
    LinkFontName = 'Arial'
    TextEncoding = ASCIIEncoding
    Left = 819
    Top = 463
  end
  object QRExcelFilter1: TQRExcelFilter
    TextEncoding = DefaultEncoding
    Left = 817
    Top = 512
  end
  object QRRTFFilter1: TQRRTFFilter
    TextEncoding = DefaultEncoding
    Left = 821
    Top = 560
  end
  object CDS: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'PRV'
    Left = 752
    Top = 224
  end
  object PRV: TDataSetProvider
    DataSet = RelNFOperacoes
    Left = 752
    Top = 312
  end
  object NFOperacoes: TQuery
    DatabaseName = 'industrial'
    SQL.Strings = (
      'SELECT N.ID_OPERACAO, N.DESCRICAO, N.CFOP, N.TIPONF,'
      '(CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_ICMS_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      ' END) TIPOTRIBUTACAO,'
      '(CASE WHEN N.NFOPER_IPI_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_IPI_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_IPI_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      'END) TIPOTRIBUTACAOIPI,'
      '(CASE WHEN N.NFOPER_PIS_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_PIS_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_PIS_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      'END) TIPOTRIBUTACAOPIS,'
      '(CASE WHEN N.NFOPER_COFINS_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_COFINS_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_COFINS_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      'END) TIPOTRIBUTACAOCOFINS,'
      '(CASE WHEN N.NFOPER_ISSQN_TIPOTRIB = 0 THEN '
      
        '  '#39'0 - Tributa'#231#227'o Fixa - Todas NCMS possuem a mesma configura'#231#227'o' +
        ' de imposto'#39
      ' ELSE'
      '  CASE WHEN N.NFOPER_ISSQN_TIPOTRIB = 1 THEN '
      '   '#39'1 - Vari'#225'vel por NCM'#39
      '  ELSE'
      '   CASE WHEN N.NFOPER_ISSQN_TIPOTRIB = 2 THEN '
      '    '#39'2 - Vari'#225'vel por NCM e por Estado'#39
      '   END'
      '  END'
      'END) TIPOTRIBUTACAOISSQN'
      'FROM NF_OPERACOES N')
    Left = 797
    Top = 17
    object NFOperacoesID_OPERACAO: TFloatField
      FieldName = 'ID_OPERACAO'
    end
    object NFOperacoesDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 100
    end
    object NFOperacoesCFOP: TStringField
      FieldName = 'CFOP'
      Size = 5
    end
    object NFOperacoesTIPONF: TStringField
      FieldName = 'TIPONF'
      FixedChar = True
      Size = 1
    end
    object NFOperacoesTIPOTRIBUTACAO: TStringField
      FieldName = 'TIPOTRIBUTACAO'
      Size = 72
    end
    object NFOperacoesTIPOTRIBUTACAOIPI: TStringField
      FieldName = 'TIPOTRIBUTACAOIPI'
      Size = 72
    end
    object NFOperacoesTIPOTRIBUTACAOPIS: TStringField
      FieldName = 'TIPOTRIBUTACAOPIS'
      Size = 72
    end
    object NFOperacoesTIPOTRIBUTACAOCOFINS: TStringField
      FieldName = 'TIPOTRIBUTACAOCOFINS'
      Size = 72
    end
    object NFOperacoesTIPOTRIBUTACAOISSQN: TStringField
      FieldName = 'TIPOTRIBUTACAOISSQN'
      Size = 72
    end
  end
  object CDSNFOPERACOES: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'PRV'
    Left = 800
    Top = 72
    object CDSNFOPERACOESID_OPERACAO: TFloatField
      FieldName = 'ID_OPERACAO'
    end
    object CDSNFOPERACOESDESCRICAO: TStringField
      FieldName = 'DESCRICAO'
      Size = 100
    end
    object CDSNFOPERACOESCFOP: TStringField
      FieldName = 'CFOP'
      Size = 5
    end
    object CDSNFOPERACOESTIPONF: TStringField
      FieldName = 'TIPONF'
      FixedChar = True
      Size = 1
    end
    object CDSNFOPERACOESTIPOTRIBUTACAO: TStringField
      FieldName = 'TIPOTRIBUTACAO'
      Size = 72
    end
    object CDSNFOPERACOESTIPOTRIBUTACAOIPI: TStringField
      FieldName = 'TIPOTRIBUTACAOIPI'
      Size = 72
    end
    object CDSNFOPERACOESTIPOTRIBUTACAOPIS: TStringField
      FieldName = 'TIPOTRIBUTACAOPIS'
      Size = 72
    end
    object CDSNFOPERACOESTIPOTRIBUTACAOCOFINS: TStringField
      FieldName = 'TIPOTRIBUTACAOCOFINS'
      Size = 72
    end
    object CDSNFOPERACOESTIPOTRIBUTACAOISSQN: TStringField
      FieldName = 'TIPOTRIBUTACAOISSQN'
      Size = 72
    end
    object CDSNFOPERACOESTIPOIMPOSTO: TStringField
      FieldName = 'TIPOIMPOSTO'
      Size = 6
    end
  end
end
